connect System DSN on windows cli via ODBC to PostgreSQL srv on GNU/Linux

--0-1180087820-1151600398=:98633
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,

i'm trying to connect a 'simple' System DSN in a windowsXP machine throug=
h ODBC to the PostgreSQL server 7.4.6 on a GNU/Linux machine, and i'm get=
ting this meessage : "Could not connect to remote socket."

I've search the pgsql configuration, and i just can't find the way to sol=
ve this issue.

Thanks in advanced

=09
---------------------------------
1GB gratis, Antivirus y Antispam
Correo Yahoo!, el mejor correo web del mundo
Abr=ED tu cuenta aqu=ED
--0-1180087820-1151600398=:98633
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,

i'm trying to connect a 'simple' System DSN in a windowsXP mac=
hine through ODBC to the PostgreSQL server 7.4.6 on a GNU/Linux machine, =
and i'm getting this meessage : "Could not connect to remote socket."
=

I've search the pgsql configuration, and i just can't find the way to=
solve this issue.

Thanks in advanced

Re: connect System DSN on windows cli via ODBC to PostgreSQL srv on GNU/Linux

> i'm trying to connect a 'simple' System DSN in a windowsXP machine
> through ODBC to the PostgreSQL server 7.4.6 on a GNU/Linux machine,
> and i'm getting this meessage : "Could not connect to remote socket."

The message means that ODBC driver is unable to connect to the backend.
What about firewall? Does postmaster running with -i (to accept tcp
connection) on Linux box? Do you properly set the hostname and port
number? What psqlODBC driver version do you use?

I'm sorry I have no crystal ball.

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: connect System DSN on windows cli via ODBC to PostgreSQL srv on GNU/Linux

Hello,

> sorry for de lack of info; there's no firewall, postmaster is
> not running with '-i' option but i have the "tcpip_socket =3D true"

Does netstat (on the server) list the pgsql server listening on 5432?

> in my postgresql.conf; in the hostname a set the IP of the server,
> the port is the default 5432; the psqlODBC driver is 07.03.0200.
>=20
> Do you know what odbc library on the server could be missing here?

No ODBC library is needed on the server side. Could you connect to the
server with psql or pgadmin from the WinXP (client) machine?
I think 07.03 doesn't have problem with IP (as 08.01 has it) but please
try define hostname with its name.

What gives you on WinXP when you try 'telnet 5432' from
command line?

BTW I'm going to holidays for one or two weeks so please reply to the
mailing list. Others could help you too ;-)

Regards,

Luf

P.S. Cc: pgsql-odbc@postgresql.org

> Ludek Finstrle escribi=F3:
> i'm trying to connect a 'simple' System DSN in a windowsXP machine
> > through ODBC to the PostgreSQL server 7.4.6 on a GNU/Linux machine,
> > and i'm getting this meessage : "Could not connect to remote socket."
>=20
> The message means that ODBC driver is unable to connect to the backend.
> What about firewall? Does postmaster running with -i (to accept tcp
> connection) on Linux box? Do you properly set the hostname and port
> number? What psqlODBC driver version do you use?
>=20
> I'm sorry I have no crystal ball.
>=20
> Regards,
>=20
> Luf
>=20
>=20
> =09
> ---------------------------------
> Yahoo! Autos. M=E1s de 12.000 veh=EDculos publicados.
> =BFQu=E9 esper=E1s para vender el tuyo?=20
> Hacelo ahora y ganate un premio de Yahoo!=20

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster